﻿

-- 人员明细考勤表
create procedure [dbo].[Report_Rymx]
@qybmm varchar(100) = null,
@begindate datetime = null,
@enddate datetime = null
as

select xm,sfzh,kqsj,kqlx 
from kqjl_info
where (@qybmm is null or qybmm=@qybmm) and (@begindate is null or kqsj>=@begindate)
and (@enddate is null or kqsj<=@enddate)